Our WAL backup documentation says in some parts of it:
..."%p is replaced by the absolute path of the file to archive..." [1]
I think this is (at least for 8.1 and upcoming 8.2 releases) wrong, since
the archiver
replaces this with pg_xlog/<LOGFILENAME> only, so that the archive command
is invoked with the relative path to the database data directory and its
xlog files. This
applies to the restore_command as well. Attached is a small patch against
HEAD, which
will adjust things in the documentation.
[1]
http://www.postgresql.org/docs/8.1/interactive/backup-online.html#BACKUP-ARCHIVING-WAL
--
Thanks
Bernd